TYPE=VIEW
query=(select `db_iwms_new`.`tbl_product`.`product_id` AS `product_id`,`db_iwms_new`.`tbl_product`.`product_code` AS `product_code`,`db_iwms_new`.`tbl_product`.`product_name` AS `product_name`,`db_iwms_new`.`tbl_product`.`product_product_group_code` AS `product_product_group_code`,`db_iwms_new`.`tbl_product`.`product_warehouse_group_code` AS `product_warehouse_group_code`,`db_iwms_new`.`tbl_product`.`product_instore_max` AS `product_instore_max`,`db_iwms_new`.`tbl_product`.`product_instore_min` AS `product_instore_min`,`db_iwms_new`.`tbl_product`.`product_note` AS `product_note`,`db_iwms_new`.`tbl_product`.`product_type` AS `product_type`,`db_iwms_new`.`tbl_product`.`product_order` AS `product_order`,`db_iwms_new`.`tbl_product`.`product_status` AS `product_status`,`db_iwms_new`.`tbl_product`.`product_unit_change_code` AS `product_unit_change_code` from `db_iwms_new`.`tbl_product` where (`db_iwms_new`.`tbl_product`.`product_status` = 1))
md5=bf96d6dc6cb4bee9e7597801f7018835
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2011-10-22 15:30:45
create-version=1
source=(select `db_iwms_new`.`tbl_product`.`product_id` AS `product_id`,`db_iwms_new`.`tbl_product`.`product_code` AS `product_code`,`db_iwms_new`.`tbl_product`.`product_name` AS `product_name`,`db_iwms_new`.`tbl_product`.`product_product_group_code` AS `product_product_group_code`,`db_iwms_new`.`tbl_product`.`product_warehouse_group_code` AS `product_warehouse_group_code`,`db_iwms_new`.`tbl_product`.`product_instore_max` AS `product_instore_max`,`db_iwms_new`.`tbl_product`.`product_instore_min` AS `product_instore_min`,`db_iwms_new`.`tbl_product`.`product_note` AS `product_note`,`db_iwms_new`.`tbl_product`.`product_type` AS `product_type`,`db_iwms_new`.`tbl_product`.`product_order` AS `product_order`,`db_iwms_new`.`tbl_product`.`product_status` AS `product_status`,`db_iwms_new`.`tbl_product`.`product_unit_change_code` AS `product_unit_change_code` from `tbl_product` where (`db_iwms_new`.`tbl_product`.`product_status` = 1))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=(select `db_iwms_new`.`tbl_product`.`product_id` AS `product_id`,`db_iwms_new`.`tbl_product`.`product_code` AS `product_code`,`db_iwms_new`.`tbl_product`.`product_name` AS `product_name`,`db_iwms_new`.`tbl_product`.`product_product_group_code` AS `product_product_group_code`,`db_iwms_new`.`tbl_product`.`product_warehouse_group_code` AS `product_warehouse_group_code`,`db_iwms_new`.`tbl_product`.`product_instore_max` AS `product_instore_max`,`db_iwms_new`.`tbl_product`.`product_instore_min` AS `product_instore_min`,`db_iwms_new`.`tbl_product`.`product_note` AS `product_note`,`db_iwms_new`.`tbl_product`.`product_type` AS `product_type`,`db_iwms_new`.`tbl_product`.`product_order` AS `product_order`,`db_iwms_new`.`tbl_product`.`product_status` AS `product_status`,`db_iwms_new`.`tbl_product`.`product_unit_change_code` AS `product_unit_change_code` from `db_iwms_new`.`tbl_product` where (`db_iwms_new`.`tbl_product`.`product_status` = 1))
